Creating 3nd and 4th Line and Clustered Column Chart visuals
16
Visual 3: Line and Clustered column Chart- Shark Attacks Per Yr & %DOD by Type.
Step 1:
a. Create line and clustered column chart for Shark Attacks Per Yr & %DOD by Type and Fatal-
NonFatal column.
b. This is illustrated by using a GIF, follow along to create this line and clustered column chart.
c. You will copy and paste the previous line and clustered column chart. Ctrl C to copy and
Ctrl V to paste.
d. In shared axis, delete Decade, Year and Month then drag and drop Fatal-Nonfatal, and Type columns in the fields.
Step 2: In format go to title and change the title to Shark Attacks Per Yr %DOD by Type

Visual 4 : Line and Clustered column Chart- Shark Attacks Per Yr & %DOD by Species,
Season & TimeOfDay
Step 1:
a. Create Shark Attacks Per Yr & %DOD by Species, Seasons &TimeOfDay columns chart.
b. This is illustrated by using a GIF, follow along to create this line and clustered column chart.
c. You will copy and paste the previous line and clustered column chart. Ctrl C to copy
and Ctrl V to paste.
d. In shared axis, delete Fatal-NonFatal column and Type columns then drag and drop Shark
Group, SpeciesAll, Season, and Time columns in the shared axis.
Step 2: In format go to title and change the title to Shark Attacks Per Yr %DOD by Species, Season & TimeOfDay.
Add Season and Time columns in the tooltip.
Create a combo chart with two axes:
Creating 3nd and 4th Line and Clustered Column Chart visuals
16
Visual 3: Line and Clustered column Chart- Shark Attacks Per Yr & %DOD by Type.
Step 1:
a. Create line and clustered column chart for Shark Attacks Per Yr & %DOD by Type and Fatal-
NonFatal column.
b. This is illustrated by using a GIF, follow along to create this line and clustered column chart.
c. You will copy and paste the previous line and clustered column chart. Ctrl C to copy and
Ctrl V to paste.
d. In shared axis, delete Decade, Year and Month then drag and drop Fatal-Nonfatal, and Type columns in the fields.
Step 2: In format go to title and change the title to Shark Attacks Per Yr %DOD by Type

Visual 4 : Line and Clustered column Chart- Shark Attacks Per Yr & %DOD by Species,
Season & TimeOfDay
Step 1:
a. Create Shark Attacks Per Yr & %DOD by Species, Seasons &TimeOfDay columns chart.
b. This is illustrated by using a GIF, follow along to create this line and clustered column chart.
c. You will copy and paste the previous line and clustered column chart. Ctrl C to copy
and Ctrl V to paste.
d. In shared axis, delete Fatal-NonFatal column and Type columns then drag and drop Shark
Group, SpeciesAll, Season, and Time columns in the shared axis.
Step 2: In format go to title and change the title to Shark Attacks Per Yr %DOD by Species, Season & TimeOfDay.
Add Season and Time columns in the tooltip.
Create a combo chart with two axes: